<html><head><title>Changes affecting table "address"</title><LINK REL ="stylesheet" TYPE="text/css" HREF="../../stylesheet.css" TITLE="Style"><SCRIPT type="text/javascript">function windowTitle(){    parent.document.title="Changes affecting table "address"";}</SCRIPT></head><body BGCOLOR="white" onload="windowTitle();"><H2>Changes affecting table "address"</H2>
<P><TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TD COLSPAN=2><FONT SIZE="+2">
<B>Current Columns</B></FONT></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD VALIGN="top">
int</TD>
<TD VALIGN="top">
<A HREF="../columns/address.id.html">id</A></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD VALIGN="top">
varchar(255)</TD>
<TD VALIGN="top">
<A HREF="../columns/address.line1.html">line1</A></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD VALIGN="top">
varchar(255)</TD>
<TD VALIGN="top">
<A HREF="../columns/address.line2.html">line2</A></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD VALIGN="top">
varchar(255)</TD>
<TD VALIGN="top">
<A HREF="../columns/address.city.html">city</A></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD VALIGN="top">
char(2)</TD>
<TD VALIGN="top">
<A HREF="../columns/address.state.html">state</A></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD VALIGN="top">
varchar(20)</TD>
<TD VALIGN="top">
<A HREF="../columns/address.postalcode.html">postalcode</A></TD>
</TR>
</TABLE>
<p><TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TD COLSPAN='4'><FONT SIZE="+2">
<B>Pending Changes</B></FONT></TD>
</TR>
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD VALIGN="top">
<a href='../changelogs/changelogs/mysql/complete/root.changelog.xml.xml'>changelogs/mysql/complete/root.changelog.xml</a></TD>
<TD VALIGN="top">
54</TD>
<TD VALIGN="top">
<a href='../authors/nvoxland.html'>nvoxland</a></TD>
<TD VALIGN="top">
NOT YET RAN [<a href='../pending/sql.html#changelogs_mysql_complete_root_changelog_xml____54____nvoxland'>SQL</a>]</TD>
</TR><TR BGCOLOR="white" CLASS="TableRowColor">
<td colspan='4'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Column newcol(varchar(255)) added to address</td></TR><TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD VALIGN="top">
<a href='../changelogs/changelogs/mysql/complete/root.changelog.xml.xml'>changelogs/mysql/complete/root.changelog.xml</a></TD>
<TD VALIGN="top">
55</TD>
<TD VALIGN="top">
<a href='../authors/nvoxland.html'>nvoxland</a></TD>
<TD VALIGN="top">
NOT YET RAN [<a href='../pending/sql.html#changelogs_mysql_complete_root_changelog_xml____55____nvoxland'>SQL</a>]</TD>
</TR><TR BGCOLOR="white" CLASS="TableRowColor">
<td colspan='4'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Column newcol2(varchar(255)) added to address</td></TR></TABLE>&nbsp;</P><p><TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TD COLSPAN='4'><FONT SIZE="+2">
<B>Past Changes</B></FONT></TD>
</TR>
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD VALIGN="top">
<a href='../changelogs/changelogs/mysql/complete/root.changelog.xml.xml'>changelogs/mysql/complete/root.changelog.xml</a></TD>
<TD VALIGN="top">
25</TD>
<TD VALIGN="top">
<a href='../authors/nvoxland.html'>nvoxland</a></TD>
<TD VALIGN="top">
Executed 11/15/07 9:37 AM</TD>
</TR><TR BGCOLOR="white" CLASS="TableRowColor">
<td colspan='4'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Table address created</td></TR><TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD VALIGN="top">
<a href='../changelogs/changelogs/mysql/complete/root.changelog.xml.xml'>changelogs/mysql/complete/root.changelog.xml</a></TD>
<TD VALIGN="top">
25.1</TD>
<TD VALIGN="top">
<a href='../authors/nvoxland.html'>nvoxland</a></TD>
<TD VALIGN="top">
Executed 11/15/07 9:37 AM</TD>
</TR><TR BGCOLOR="white" CLASS="TableRowColor">
<td colspan='4'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Null constraint has been added to address.id</td></TR><TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD VALIGN="top">
<a href='../changelogs/changelogs/mysql/complete/root.changelog.xml.xml'>changelogs/mysql/complete/root.changelog.xml</a></TD>
<TD VALIGN="top">
25.2</TD>
<TD VALIGN="top">
<a href='../authors/nvoxland.html'>nvoxland</a></TD>
<TD VALIGN="top">
Executed 11/15/07 9:37 AM</TD>
</TR><TR BGCOLOR="white" CLASS="TableRowColor">
<td colspan='4'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Primary key added to address (id)</td></TR><TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD VALIGN="top">
<a href='../changelogs/changelogs/mysql/complete/root.changelog.xml.xml'>changelogs/mysql/complete/root.changelog.xml</a></TD>
<TD VALIGN="top">
25.3</TD>
<TD VALIGN="top">
<a href='../authors/nvoxland.html'>nvoxland</a></TD>
<TD VALIGN="top">
Executed 11/15/07 9:37 AM</TD>
</TR><TR BGCOLOR="white" CLASS="TableRowColor">
<td colspan='4'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Auto-increment added to address.id</td></TR><TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD VALIGN="top">
<a href='../changelogs/changelogs/mysql/complete/root.changelog.xml.xml'>changelogs/mysql/complete/root.changelog.xml</a></TD>
<TD VALIGN="top">
26</TD>
<TD VALIGN="top">
<a href='../authors/nvoxland.html'>nvoxland</a></TD>
<TD VALIGN="top">
Executed 11/15/07 9:37 AM</TD>
</TR><TR BGCOLOR="white" CLASS="TableRowColor">
<td colspan='4'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;New row inserted into address</td></TR><TR BGCOLOR="white" CLASS="TableRowColor">
<td colspan='4'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;New row inserted into address</td></TR><TR BGCOLOR="white" CLASS="TableRowColor">
<td colspan='4'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;New row inserted into address</td></TR><TR BGCOLOR="white" CLASS="TableRowColor">
<td colspan='4'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;New row inserted into address</td></TR><TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD VALIGN="top">
<a href='../changelogs/changelogs/mysql/complete/root.changelog.xml.xml'>changelogs/mysql/complete/root.changelog.xml</a></TD>
<TD VALIGN="top">
27</TD>
<TD VALIGN="top">
<a href='../authors/nvoxland.html'>nvoxland</a></TD>
<TD VALIGN="top">
Executed 11/15/07 9:37 AM</TD>
</TR><TR BGCOLOR="white" CLASS="TableRowColor">
<td colspan='4'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Lookup table added for address.state</td></TR><TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD VALIGN="top">
<a href='../changelogs/changelogs/mysql/complete/root.changelog.xml.xml'>changelogs/mysql/complete/root.changelog.xml</a></TD>
<TD VALIGN="top">
28</TD>
<TD VALIGN="top">
<a href='../authors/nvoxland.html'>nvoxland</a></TD>
<TD VALIGN="top">
Executed 11/15/07 9:37 AM</TD>
</TR><TR BGCOLOR="white" CLASS="TableRowColor">
<td colspan='4'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Default value added to address.line2</td></TR><TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD VALIGN="top">
<a href='../changelogs/changelogs/mysql/complete/root.changelog.xml.xml'>changelogs/mysql/complete/root.changelog.xml</a></TD>
<TD VALIGN="top">
29</TD>
<TD VALIGN="top">
<a href='../authors/nvoxland.html'>nvoxland</a></TD>
<TD VALIGN="top">
Executed 11/15/07 9:37 AM</TD>
</TR><TR BGCOLOR="white" CLASS="TableRowColor">
<td colspan='4'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Default value dropped from address.line2</td></TR><TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD VALIGN="top">
<a href='../changelogs/changelogs/mysql/complete/root.changelog.xml.xml'>changelogs/mysql/complete/root.changelog.xml</a></TD>
<TD VALIGN="top">
33</TD>
<TD VALIGN="top">
<a href='../authors/nvoxland.html'>nvoxland</a></TD>
<TD VALIGN="top">
Executed 11/15/07 9:37 AM</TD>
</TR><TR BGCOLOR="white" CLASS="TableRowColor">
<td colspan='4'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Unique constraint added to address(line1, line2)</td></TR><TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD VALIGN="top">
<a href='../changelogs/changelogs/mysql/complete/root.changelog.xml.xml'>changelogs/mysql/complete/root.changelog.xml</a></TD>
<TD VALIGN="top">
34</TD>
<TD VALIGN="top">
<a href='../authors/nvoxland.html'>nvoxland</a></TD>
<TD VALIGN="top">
Executed 11/15/07 9:38 AM</TD>
</TR><TR BGCOLOR="white" CLASS="TableRowColor">
<td colspan='4'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Unique constraint uq_address_line1line2 dropped from address</td></TR><TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD VALIGN="top">
<a href='../changelogs/changelogs/mysql/complete/root.changelog.xml.xml'>changelogs/mysql/complete/root.changelog.xml</a></TD>
<TD VALIGN="top">
54</TD>
<TD VALIGN="top">
<a href='../authors/nvoxland.html'>nvoxland</a></TD>
<TD VALIGN="top">
NOT YET RAN [<a href='../pending/sql.html#changelogs_mysql_complete_root_changelog_xml____54____nvoxland'>SQL</a>]</TD>
</TR><TR BGCOLOR="white" CLASS="TableRowColor">
<td colspan='4'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Column newcol(varchar(255)) added to address</td></TR><TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD VALIGN="top">
<a href='../changelogs/changelogs/mysql/complete/root.changelog.xml.xml'>changelogs/mysql/complete/root.changelog.xml</a></TD>
<TD VALIGN="top">
55</TD>
<TD VALIGN="top">
<a href='../authors/nvoxland.html'>nvoxland</a></TD>
<TD VALIGN="top">
NOT YET RAN [<a href='../pending/sql.html#changelogs_mysql_complete_root_changelog_xml____55____nvoxland'>SQL</a>]</TD>
</TR><TR BGCOLOR="white" CLASS="TableRowColor">
<td colspan='4'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Column newcol2(varchar(255)) added to address</td></TR></TABLE>&nbsp;</P><hr>Generated: 11/15/07 9:57 AM<BR>Against: liquibase @ jdbc:mysql://localhost/liquibase<BR>Change Log: changelogs/mysql/complete/root.changelog.xml<BR><BR>Generated By: <a href='http://www.liquibase.org' target='_TOP'>LiquiBase 1.3.3</a></body></html>